Conceptual Model: UML

Click here to view the conceptual model in Lucid Chart.

Conceptual UML

Logical Model: ERD

Click here to view the logical model in Lucid Chart.

Logical ERD

Schema

Click here to view the schema in Google Docs.

schema

Creating Database Tables

Populating The Database

Queries

LS0tCnRpdGxlOiAnQ1M1MjAwIEZhbGwgMjAyMDogUHJhY3RpY3VtIDEnCmF1dGhvcjogIkNoYW5kcmEgRGF2aXMsIEV2YW4gRG91Z2xhc3MiCm91dHB1dDoKICBwZGZfZG9jdW1lbnQ6IGRlZmF1bHQKICBodG1sX25vdGVib29rOiBkZWZhdWx0Ci0tLQoKIyMgQ29uY2VwdHVhbCBNb2RlbDogVU1MCgoKW0NsaWNrIGhlcmUgIHRvIHZpZXcgdGhlIGNvbmNlcHR1YWwgbW9kZWwgaW4gTHVjaWQgQ2hhcnQuXShodHRwczovL2FwcC5sdWNpZGNoYXJ0LmNvbS9pbnZpdGF0aW9ucy9hY2NlcHQvNTYwMjMxMmUtZGZjMy00NDIzLTk3NWMtNDcxOTBjZTYwMjJlKQoKPCEtLSBFbnN1cmUgdGhpcyBpcyB0aGUgbW9zdCB1cCB0byBkYXRlIGltYWdlIC0tPgohW0NvbmNlcHR1YWwgVU1MXShDUzUyMDAgLSBQcmFjdGljdW0gMV9VTUwucG5nKVwKCiMjIExvZ2ljYWwgTW9kZWw6IEVSRAoKW0NsaWNrIGhlcmUgIHRvIHZpZXcgdGhlIGxvZ2ljYWwgbW9kZWwgaW4gTHVjaWQgQ2hhcnQuXShodHRwczovL2FwcC5sdWNpZGNoYXJ0LmNvbS9pbnZpdGF0aW9ucy9hY2NlcHQvN2I0OTdjYmYtMjY4ZC00YTAzLWIxYTctODIyYjVhODQ0ZmVhKQoKPCEtLSBFbnN1cmUgdGhpcyBpcyB0aGUgbW9zdCB1cCB0byBkYXRlIGltYWdlIC0tPgohW0xvZ2ljYWwgRVJEXShDUzUyMDAgLSBQcmFjdGljdW0gMV9FUkQucG5nKVwKCiMjIFNjaGVtYQoKW0NsaWNrIGhlcmUgIHRvIHZpZXcgdGhlIHNjaGVtYSBpbiBHb29nbGUgRG9jcy5dKGh0dHBzOi8vZG9jcy5nb29nbGUuY29tL2RvY3VtZW50L2QvMW84cGs1MWFlZDNCSlNhQmN3TzJFTWJUOEkzcnVfd3BHVGNUTjRXLURiSU0vZWRpdD91c3A9c2hhcmluZykKCjwhLS0gRW5zdXJlIHRoaXMgaXMgdGhlIG1vc3QgdXAgdG8gZGF0ZSBpbWFnZSAtLT4KIVtzY2hlbWFdKFByYWN0aWN1bTEtU2NoZW1hLnBuZylcCgojIyBDcmVhdGluZyBEYXRhYmFzZSBUYWJsZXMKCiMjIFBvcHVsYXRpbmcgVGhlIERhdGFiYXNlCgojIyBRdWVyaWVz